package com.aaa.mapper;

import com.aaa.entity.Singer;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

//歌手管理q
public interface SingerMapper extends BaseMapper<Singer> {
    @Select("select * from singer where id LIKE '%${id}%'")
    List<Singer> selectid(Integer searchId);
    @Select("insert into singer(name,sex,pic,birth,location,introduction)values(#{name},#{sex})" +
            ",#{pic},#{birth},#{location},#{introduction}")
    int add(Singer singer);
    @Select("update singer set name=#{name},sex=#{sex},pic=#{pic},birth=#{birth},location=#" +
            "{location},introduction=#{introduction} where id=#{id}")
    int update(Singer singer);
}
